package com.fengxing.ams.web.facade.mouble.enrollment;

import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;

import com.fengxing.ams.web.facade.mouble.college.CollegeVO;
import com.fengxing.ams.web.facade.mouble.major.MajorBaseVO;
import com.fengxing.ams.web.facade.mouble.student.StudentVO;

@Entity
@Table(name = "zyt_major_enrollment")
public class MajorEnrollmentVO implements java.io.Serializable {

	private static final long serialVersionUID = -7276471594260397142L;
	@Id
	private Integer id                      ;
	private Integer college_id              ;
	private Integer major_id                ;
	private Integer description_id          ;
	private Integer year                    ;
	private String batch                   ;
	private String subject                 ;
	@Column(name="max_score")
	private Integer maxScore               ;
	@Column(name="min_score")
	private Integer minScore               ;
	@Column(name="avg_score")
	private Integer avgScore               ;
	@Column(name="min_ranking")
	private Integer minRanking             ;
	private Integer apply                   ;
	private Integer enrolled                ;
	private Integer enroll_plan             ;
	private String college_code            ;
	private String major_code              ;
	private String college_type;
	private Integer q_2;
	private Integer q_9;
	private Integer q_y;
	@ManyToOne(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY, optional = false)  
    @JoinColumn(name = "college_id",  insertable = false, updatable = false)
	private CollegeVO collegeVO;
	@ManyToOne(cascade = CascadeType.REFRESH, fetch = FetchType.LAZY, optional = false)  
    @JoinColumn(name = "major_id",  insertable = false, updatable = false)
	private MajorBaseVO majorBaseVO;
//	@OneToMany(cascade=CascadeType.REFRESH , fetch = FetchType.LAZY)
//	@JoinTable(name="zyt_student",
//    joinColumns={
//			@JoinColumn(name="college_id",referencedColumnName="college_id"),
//			@JoinColumn(name="major_id",referencedColumnName="major_id"),
//			@JoinColumn(name="batch",referencedColumnName="batch"),
//			@JoinColumn(name="subject",referencedColumnName="subject")
//    	}
//    )
//	private List<StudentVO> students;
//	
//	public List<StudentVO> getStudents() {
//		return students;
//	}
//	public void setStudents(List<StudentVO> students) {
//		this.students = students;
//	}
	public CollegeVO getCollegeVO() {
		return collegeVO;
	}
	public String getCollege_type() {
		return college_type;
	}
	public void setCollege_type(String college_type) {
		this.college_type = college_type;
	}
	public Integer getQ_2() {
		return q_2;
	}
	public void setQ_2(Integer q_2) {
		this.q_2 = q_2;
	}
	public Integer getQ_9() {
		return q_9;
	}
	public void setQ_9(Integer q_9) {
		this.q_9 = q_9;
	}
	public Integer getQ_y() {
		return q_y;
	}
	public void setQ_y(Integer q_y) {
		this.q_y = q_y;
	}
	public static long getSerialversionuid() {
		return serialVersionUID;
	}
	public void setCollegeVO(CollegeVO collegeVO) {
		this.collegeVO = collegeVO;
	}
	public MajorBaseVO getMajorBaseVO() {
		return majorBaseVO;
	}
	public void setMajorBaseVO(MajorBaseVO majorBaseVO) {
		this.majorBaseVO = majorBaseVO;
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public Integer getCollege_id() {
		return college_id;
	}
	public void setCollege_id(Integer college_id) {
		this.college_id = college_id;
	}
	public Integer getMajor_id() {
		return major_id;
	}
	public void setMajor_id(Integer major_id) {
		this.major_id = major_id;
	}
	public Integer getDescription_id() {
		return description_id;
	}
	public void setDescription_id(Integer description_id) {
		this.description_id = description_id;
	}
	public Integer getYear() {
		return year;
	}
	public void setYear(Integer year) {
		this.year = year;
	}
	public String getBatch() {
		return batch;
	}
	public void setBatch(String batch) {
		this.batch = batch;
	}
	public String getSubject() {
		return subject;
	}
	public void setSubject(String subject) {
		this.subject = subject;
	}
	public Integer getMaxScore() {
		return maxScore;
	}
	public void setMaxScore(Integer max_score) {
		this.maxScore = max_score;
	}
	public Integer getMinScore() {
		return minScore;
	}
	public void setMinScore(Integer min_score) {
		this.minScore = min_score;
	}
	public Integer getAvgScore() {
		return avgScore;
	}
	public void setAvgScore(Integer avg_score) {
		this.avgScore = avg_score;
	}
	public Integer getMinRanking() {
		return minRanking;
	}
	public void setMinRanking(Integer min_ranking) {
		this.minRanking = min_ranking;
	}
	public Integer getApply() {
		return apply;
	}
	public void setApply(Integer apply) {
		this.apply = apply;
	}
	public Integer getEnrolled() {
		return enrolled;
	}
	public void setEnrolled(Integer enrolled) {
		this.enrolled = enrolled;
	}
	public Integer getEnroll_plan() {
		return enroll_plan;
	}
	public void setEnroll_plan(Integer enroll_plan) {
		this.enroll_plan = enroll_plan;
	}
	public String getCollege_code() {
		return college_code;
	}
	public void setCollege_code(String college_code) {
		this.college_code = college_code;
	}
	public String getMajor_code() {
		return major_code;
	}
	public void setMajor_code(String major_code) {
		this.major_code = major_code;
	}
	
	
}
